10.1

10.2

10.3

10.4
EXECUTE sp_grantlogin 'zhenaj\student'

10.5

10.6
EXECUTE sp_addlogin  'STU','123456','myDB'

10.7
EXECUTE sp_droplogin 'STU'
EXECUTE sp_revokelogin ' zhenaj\student'

10.8
use myDB
go
EXECUTE sp_grantdbaccess 'TEA','TEA'

10.9
use myDB
EXECUTE sp_grantdbaccess 'LEAD', 'LEAD' 
EXECUTE sp_addrolemember 'db_accessadmin','STU' 
EXECUTE sp_helpuser 'STU' --鿴ûSTUϢ

10.10
EXECUTE sp_revokedbaccess 'STU' 

10.11

10.12
EXECUTE sp_addsrvrolemember 'myadmin','sysadmin'

10.13

10.14
EXECUTE sp_dropsrvrolemember 'myadmin','sysadmin'

10.15

10.16
EXECUTE sp_addrolemember 'db_owner','zhenaj\student'

10.17

10.18
EXECUTE sp_droprolemember 'db_owner','zhenaj\student'

10.19

10.20
EXECUTE sp_addrole 'db_def_admin'

10.21
USE myDB
GO 
EXECUTE sp_droprole 'db_def_admin'


10.22
USE myDB
GO 
EXECUTE sp_droprole 'db_def_admin'

10.23
USE myDB
go
GRANT SELECT ON my_user_info TO MY
DENY INSERT,UPDATE,DELETE ON my_user_info TO MY

10.24

10.25
USE myDB
go
GRANT SELECT ON jiangchen TO db_def_tea
DENY INSERT,UPDATE,DELETE ON jiangchen TO db_def_tea

10.26

10.27
exec sp_addumpdevice 'disk','myDB_bak','D:\DataBaseBak\myDB_bak.BAK'

10.28
exec sp_dropdevice 'myDB_bak'

10.29

10.30

10.31
USE myDB
go 
BACKUP DATABASE myDB TO myDB_bak with name='myDB080416'

10.32
BACKUP DATABASE myDB TO myDB_bak
WITH DIFFERENTIAL,name='myDB챸',NOINIT

10.33
BACKUP LOG myDB TO myDB_bak WITH NOINIT

10.34
USE myDB 
exec sp_addumpdevice 'disk','myfilebackup','D:\DataBaseBak\mymyfilebackup.BAK'
BACKUP DATABASE myDB FILE='cnc_nk_data' TO myfilebackup

10.35

10.36
RESTORE DATABASE myDB FROM myDB_bak